Dataset statistics
| Number of variables | 48 |
|---|---|
| Number of observations | 15407 |
| Missing cells | 84314 |
| Missing cells (%) | 11.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.6 MiB |
| Average record size in memory | 384.0 B |
Variable types
| CAT | 36 |
|---|---|
| NUM | 12 |
Reproduction
| Analysis started | 2020-06-10 20:12:51.876921 |
|---|---|
| Analysis finished | 2020-06-10 20:13:20.033597 |
| Duration | 28.16 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Average Weekly Wage has a high cardinality: 1966 distinct values | High cardinality |
Claimant Atty Firm Name has a high cardinality: 453 distinct values | High cardinality |
Claimant Hire Date has a high cardinality: 4204 distinct values | High cardinality |
Detail Cause has a high cardinality: 63 distinct values | High cardinality |
Dt Reported to Carrier/TPA has a high cardinality: 3633 distinct values | High cardinality |
Dt Reported to Employer has a high cardinality: 4355 distinct values | High cardinality |
Date of Injury/Illness has a high cardinality: 4430 distinct values | High cardinality |
How Injury Occurred has a high cardinality: 15344 distinct values | High cardinality |
Injury/Illness City has a high cardinality: 1340 distinct values | High cardinality |
Injury/Illness Postal has a high cardinality: 1841 distinct values | High cardinality |
Injury/Illness State has a high cardinality: 53 distinct values | High cardinality |
Injury/Illness State Code has a high cardinality: 53 distinct values | High cardinality |
Detail Cause Code is highly correlated with Cause Code | High correlation |
Cause Code is highly correlated with Detail Cause Code | High correlation |
Claimant Gender Code is highly correlated with Claimant Gender | High correlation |
Claimant Gender is highly correlated with Claimant Gender Code | High correlation |
Claimant Marital Status Code is highly correlated with Claimant Marital Status | High correlation |
Claimant Marital Status is highly correlated with Claimant Marital Status Code | High correlation |
Claimant State Code is highly correlated with Claimant State | High correlation |
Claimant State is highly correlated with Claimant State Code | High correlation |
Detail Cause is highly correlated with Cause | High correlation |
Cause is highly correlated with Detail Cause | High correlation |
Domestic vs. Foreign? Code is highly correlated with Domestic vs. Foreign? | High correlation |
Domestic vs. Foreign? is highly correlated with Domestic vs. Foreign? Code | High correlation |
Employment Status Code is highly correlated with Employment Status | High correlation |
Employment Status is highly correlated with Employment Status Code | High correlation |
Injury/Illness State Code is highly correlated with Injury/Illness State | High correlation |
Injury/Illness State is highly correlated with Injury/Illness State Code | High correlation |
Jurisdiction Code is highly correlated with Jurisdiction | High correlation |
Jurisdiction is highly correlated with Jurisdiction Code | High correlation |
Lost Time or Medical Only? Code is highly correlated with Lost Time or Medical Only? | High correlation |
Lost Time or Medical Only? is highly correlated with Lost Time or Medical Only? Code | High correlation |
OSHA Injury Type is highly correlated with Nature of Injury/Illness | High correlation |
Nature of Injury/Illness is highly correlated with OSHA Injury Type and 2 other fields | High correlation |
Type of Loss is highly correlated with Nature of Injury/Illness and 1 other fields | High correlation |
Type of Loss Code is highly correlated with Nature of Injury/Illness and 1 other fields | High correlation |
Average Weekly Wage has 9535 (61.9%) missing values | Missing |
Claimant Age has 2163 (14.0%) missing values | Missing |
Claimant Atty Firm Name has 12410 (80.5%) missing values | Missing |
Claimant Hire Date has 901 (5.8%) missing values | Missing |
Claimant Marital Status has 12693 (82.4%) missing values | Missing |
Claimant Marital Status Code has 12693 (82.4%) missing values | Missing |
Department Code has 8123 (52.7%) missing values | Missing |
Injury/Illness Postal has 3684 (23.9%) missing values | Missing |
Number of Dependents has 14808 (96.1%) missing values | Missing |
Severity Index Code has 344 (2.2%) missing values | Missing |
Severity Index Code Code has 344 (2.2%) missing values | Missing |
Reforms_dummy has 6313 (41.0%) missing values | Missing |
Dependent is highly skewed (γ1 = 27.90114494) | Skewed |
How Injury Occurred is uniformly distributed | Uniform |
Obs_ID has unique values | Unique |
Dependent has 2689 (17.5%) zeros | Zeros |
Time of Injury/Illness has 2828 (18.4%) zeros | Zeros |
| Distinct count | 15407 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| Obs_16009 | 1 |
|---|---|
| Obs_7398 | 1 |
| Obs_3079 | 1 |
| Obs_15676 | 1 |
| Obs_10003 | 1 |
| Other values (15402) |
| Value | Count | Frequency (%) | |
| Obs_16009 | 1 | < 0.1% | |
| Obs_7398 | 1 | < 0.1% | |
| Obs_3079 | 1 | < 0.1% | |
| Obs_15676 | 1 | < 0.1% | |
| Obs_10003 | 1 | < 0.1% | |
| Obs_2995 | 1 | < 0.1% | |
| Obs_17059 | 1 | < 0.1% | |
| Obs_5274 | 1 | < 0.1% | |
| Obs_2141 | 1 | < 0.1% | |
| Obs_15815 | 1 | < 0.1% | |
| Other values (15397) | 15397 | 99.9% |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.407996365 |
| Min length | 5 |
| Distinct count | 5024 |
|---|---|
| Unique (%) | 32.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10285.41370805478 |
|---|---|
| Minimum | 0 |
| Maximum | 3774290 |
| Zeros | 2689 |
| Zeros (%) | 17.5% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 152 |
| median | 446 |
| Q3 | 1703.5 |
| 95-th percentile | 51491.9 |
| Maximum | 3774290 |
| Range | 3774290 |
| Interquartile range (IQR) | 1551.5 |
Descriptive statistics
| Standard deviation | 54196.59903 |
|---|---|
| Coefficient of variation (CV) | 5.269267778 |
| Kurtosis | 1591.997702 |
| Mean | 10285.41371 |
| Median Absolute Deviation (MAD) | 446 |
| Skewness | 27.90114494 |
| Sum | 158467369 |
| Variance | 2937271346 |
| Value | Count | Frequency (%) | |
| 0 | 2689 | 17.5% | |
| 154 | 42 | 0.3% | |
| 150 | 32 | 0.2% | |
| 222 | 28 | 0.2% | |
| 215 | 27 | 0.2% | |
| 180 | 27 | 0.2% | |
| 232 | 24 | 0.2% | |
| 3 | 24 | 0.2% | |
| 167 | 23 | 0.1% | |
| 199 | 23 | 0.1% | |
| Other values (5014) | 12468 | 80.9% |
| Value | Count | Frequency (%) | |
| 0 | 2689 | 17.5% | |
| 1 | 2 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 3 | 24 | 0.2% | |
| 4 | 9 | 0.1% |
| Value | Count | Frequency (%) | |
| 3774290 | 1 | < 0.1% | |
| 1159631 | 1 | < 0.1% | |
| 1086522 | 1 | < 0.1% | |
| 1083067 | 1 | < 0.1% | |
| 1076883 | 1 | < 0.1% |
| Distinct count | 1966 |
|---|---|
| Unique (%) | 33.5% |
| Missing | 9535 |
| Missing (%) | 61.9% |
| Memory size | 120.4 KiB |
| 500 | 383 |
|---|---|
| 320 | 204 |
| 1,000.00 | 180 |
| 600 | 149 |
| 150 | 126 |
| Other values (1961) |
| Value | Count | Frequency (%) | |
| 500 | 383 | 2.5% | |
| 320 | 204 | 1.3% | |
| 1,000.00 | 180 | 1.2% | |
| 600 | 149 | 1.0% | |
| 150 | 126 | 0.8% | |
| 100 | 121 | 0.8% | |
| 400 | 84 | 0.5% | |
| 1,500.00 | 70 | 0.5% | |
| 1,200.00 | 68 | 0.4% | |
| 300 | 61 | 0.4% | |
| Other values (1956) | 4426 | 28.7% | |
| (Missing) | 9535 | 61.9% |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 3.984812098 |
| Min length | 1 |
Body Part
Categorical
| Distinct count | 46 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| Finger(s) | 1426 |
|---|---|
| Low Back Area | 1317 |
| Knee | 1236 |
| Other Facial Soft Tissue | 1113 |
| Eye(s) | 1028 |
| Other values (41) |
| Value | Count | Frequency (%) | |
| Finger(s) | 1426 | 9.3% | |
| Low Back Area | 1317 | 8.5% | |
| Knee | 1236 | 8.0% | |
| Other Facial Soft Tissue | 1113 | 7.2% | |
| Eye(s) | 1028 | 6.7% | |
| Ankle | 909 | 5.9% | |
| Hand | 816 | 5.3% | |
| Shoulder(s) | 740 | 4.8% | |
| Foot | 617 | 4.0% | |
| Lower Leg | 568 | 3.7% | |
| Other values (36) | 5637 | 36.6% |
Length
| Max length | 54 |
|---|---|
| Median length | 6 |
| Mean length | 10.31161161 |
| Min length | 3 |
Body Part Code
Real number (ℝ≥0)
| Distinct count | 46 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.06542480690595 |
|---|---|
| Minimum | 10 |
| Maximum | 90 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 33 |
| median | 38 |
| Q3 | 53 |
| 95-th percentile | 65 |
| Maximum | 90 |
| Range | 80 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 17.20610687 |
|---|---|
| Coefficient of variation (CV) | 0.4189925455 |
| Kurtosis | 0.5526765595 |
| Mean | 41.06542481 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 0.4648007928 |
| Sum | 632695 |
| Variance | 296.0501137 |
| Value | Count | Frequency (%) | |
| 36 | 1426 | 9.3% | |
| 42 | 1317 | 8.5% | |
| 53 | 1236 | 8.0% | |
| 18 | 1113 | 7.2% | |
| 14 | 1028 | 6.7% | |
| 55 | 909 | 5.9% | |
| 35 | 816 | 5.3% | |
| 38 | 740 | 4.8% | |
| 56 | 617 | 4.0% | |
| 54 | 568 | 3.7% | |
| Other values (36) | 5637 | 36.6% |
| Value | Count | Frequency (%) | |
| 10 | 27 | 0.2% | |
| 11 | 18 | 0.1% | |
| 12 | 37 | 0.2% | |
| 13 | 128 | 0.8% | |
| 14 | 1028 | 6.7% |
| Value | Count | Frequency (%) | |
| 90 | 563 | 3.7% | |
| 66 | 78 | 0.5% | |
| 65 | 307 | 2.0% | |
| 63 | 99 | 0.6% | |
| 62 | 25 | 0.2% |
| Distinct count | 10 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| Strain or Injury By | |
|---|---|
| Fall, Slip or Trip Injury | |
| Struck or Injured By | |
| Miscellaneous Causes | |
| Cut, Puncture, Scrape Injured By | |
| Other values (5) |
| Value | Count | Frequency (%) | |
| Strain or Injury By | 4174 | 27.1% | |
| Fall, Slip or Trip Injury | 2662 | 17.3% | |
| Struck or Injured By | 2533 | 16.4% | |
| Miscellaneous Causes | 2004 | 13.0% | |
| Cut, Puncture, Scrape Injured By | 1878 | 12.2% | |
| Striking Against or Stepping on | 1009 | 6.5% | |
| Caught In, Under or Between | 558 | 3.6% | |
| Motor Vehicle | 358 | 2.3% | |
| Burn or Scald - Heat or Cold Exposure | 211 | 1.4% | |
| Rubbed or Abraded By | 20 | 0.1% |
Length
| Max length | 37 |
|---|---|
| Median length | 20 |
| Mean length | 23.09975985 |
| Min length | 13 |
| Distinct count | 10 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1497.0662685792172 |
|---|---|
| Minimum | 1000 |
| Maximum | 1900 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 1200 |
| Q1 | 1300 |
| median | 1500 |
| Q3 | 1700 |
| 95-th percentile | 1900 |
| Maximum | 1900 |
| Range | 900 |
| Interquartile range (IQR) | 400 |
Descriptive statistics
| Standard deviation | 235.5560533 |
|---|---|
| Coefficient of variation (CV) | 0.1573451077 |
| Kurtosis | -0.8318841983 |
| Mean | 1497.066269 |
| Median Absolute Deviation (MAD) | 200 |
| Skewness | 0.114962866 |
| Sum | 23065300 |
| Variance | 55486.65425 |
| Value | Count | Frequency (%) | |
| 1500 | 4174 | 27.1% | |
| 1300 | 2662 | 17.3% | |
| 1700 | 2533 | 16.4% | |
| 1900 | 2004 | 13.0% | |
| 1200 | 1878 | 12.2% | |
| 1600 | 1009 | 6.5% | |
| 1100 | 558 | 3.6% | |
| 1400 | 358 | 2.3% | |
| 1000 | 211 | 1.4% | |
| 1800 | 20 | 0.1% |
| Value | Count | Frequency (%) | |
| 1000 | 211 | 1.4% | |
| 1100 | 558 | 3.6% | |
| 1200 | 1878 | 12.2% | |
| 1300 | 2662 | 17.3% | |
| 1400 | 358 | 2.3% |
| Value | Count | Frequency (%) | |
| 1900 | 2004 | 13.0% | |
| 1800 | 20 | 0.1% | |
| 1700 | 2533 | 16.4% | |
| 1600 | 1009 | 6.5% | |
| 1500 | 4174 | 27.1% |
| Distinct count | 84 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 2163 |
| Missing (%) | 14.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.286922379945636 |
|---|---|
| Minimum | 1.0 |
| Maximum | 91.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 31 |
| median | 40 |
| Q3 | 49 |
| 95-th percentile | 60 |
| Maximum | 91 |
| Range | 90 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 11.82069754 |
|---|---|
| Coefficient of variation (CV) | 0.2934127713 |
| Kurtosis | -0.5246541589 |
| Mean | 40.28692238 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.1788198528 |
| Sum | 533560 |
| Variance | 139.7288904 |
| Value | Count | Frequency (%) | |
| 41 | 436 | 2.8% | |
| 43 | 382 | 2.5% | |
| 36 | 378 | 2.5% | |
| 47 | 377 | 2.4% | |
| 46 | 376 | 2.4% | |
| 45 | 369 | 2.4% | |
| 40 | 369 | 2.4% | |
| 39 | 366 | 2.4% | |
| 34 | 364 | 2.4% | |
| 24 | 361 | 2.3% | |
| Other values (74) | 9466 | 61.4% | |
| (Missing) | 2163 | 14.0% |
| Value | Count | Frequency (%) | |
| 1 | 6 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 91 | 1 | < 0.1% | |
| 89 | 1 | < 0.1% | |
| 85 | 1 | < 0.1% | |
| 84 | 1 | < 0.1% | |
| 83 | 2 | < 0.1% |
| Distinct count | 453 |
|---|---|
| Unique (%) | 15.1% |
| Missing | 12410 |
| Missing (%) | 80.5% |
| Memory size | 120.4 KiB |
| TLEVY, STERN & FORD | 116 |
|---|---|
| TJ. LEEDS BARROL, IV ATTORNEY AT LAW | 58 |
| TLEVY, FORD & WALLACH | 51 |
| TLEVY, STERN, & FORD | 50 |
| TCARUSO, SPILLANE, LEIGHTON,CONTRASTANO, ULANER & SAVINO | 37 |
| Other values (448) |
| Value | Count | Frequency (%) | |
| TLEVY, STERN & FORD | 116 | 0.8% | |
| TJ. LEEDS BARROL, IV ATTORNEY AT LAW | 58 | 0.4% | |
| TLEVY, FORD & WALLACH | 51 | 0.3% | |
| TLEVY, STERN, & FORD | 50 | 0.3% | |
| TCARUSO, SPILLANE, LEIGHTON,CONTRASTANO, ULANER & SAVINO | 37 | 0.2% | |
| TLAW OFFICES OF MCNAMARA & | 36 | 0.2% | |
| TMARDER, ESKESEN & NASS | 35 | 0.2% | |
| TKLEIN WAGNER & MORRIS | 34 | 0.2% | |
| TKLEE & WOOLF, LLP | 33 | 0.2% | |
| TLAW OFFICE OF CHRISTINE T. NELSON | 33 | 0.2% | |
| Other values (443) | 2514 | 16.3% | |
| (Missing) | 12410 | 80.5% |
Length
| Max length | 57 |
|---|---|
| Median length | 3 |
| Mean length | 7.532809762 |
| Min length | 3 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| Male | |
|---|---|
| Female | |
| Uknown | 82 |
| Value | Count | Frequency (%) | |
| Male | 12375 | 80.3% | |
| Female | 2950 | 19.1% | |
| Uknown | 82 | 0.5% |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.39358733 |
| Min length | 4 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| M | |
|---|---|
| F | |
| U | 82 |
| Value | Count | Frequency (%) | |
| M | 12375 | 80.3% | |
| F | 2950 | 19.1% | |
| U | 82 | 0.5% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 4204 |
|---|---|
| Unique (%) | 29.0% |
| Missing | 901 |
| Missing (%) | 5.8% |
| Memory size | 120.4 KiB |
| 1/1/2005 | 130 |
|---|---|
| 2/27/2003 | 64 |
| 1/1/2001 | 63 |
| 1/1/2008 | 32 |
| 7/15/2002 | 27 |
| Other values (4199) |
| Value | Count | Frequency (%) | |
| 1/1/2005 | 130 | 0.8% | |
| 2/27/2003 | 64 | 0.4% | |
| 1/1/2001 | 63 | 0.4% | |
| 1/1/2008 | 32 | 0.2% | |
| 7/15/2002 | 27 | 0.2% | |
| 1/7/2013 | 27 | 0.2% | |
| 1/5/2009 | 26 | 0.2% | |
| 7/1/2012 | 25 | 0.2% | |
| 1/1/2013 | 25 | 0.2% | |
| 1/5/2005 | 24 | 0.2% | |
| Other values (4194) | 14063 | 91.3% | |
| (Missing) | 901 | 5.8% |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.484195496 |
| Min length | 3 |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 12693 |
| Missing (%) | 82.4% |
| Memory size | 120.4 KiB |
| Unmarried, Single, Widowed, Divorced | |
|---|---|
| Married | |
| Separated | 21 |
| Value | Count | Frequency (%) | |
| Unmarried, Single, Widowed, Divorced | 1435 | 9.3% | |
| Married | 1258 | 8.2% | |
| Separated | 21 | 0.1% | |
| (Missing) | 12693 | 82.4% |
Length
| Max length | 36 |
|---|---|
| Median length | 3 |
| Mean length | 6.408385799 |
| Min length | 3 |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 12693 |
| Missing (%) | 82.4% |
| Memory size | 120.4 KiB |
| U | |
|---|---|
| M | |
| S | 21 |
| Value | Count | Frequency (%) | |
| U | 1435 | 9.3% | |
| M | 1258 | 8.2% | |
| S | 21 | 0.1% | |
| (Missing) | 12693 | 82.4% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.647692607 |
| Min length | 1 |
| Distinct count | 49 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| California | |
|---|---|
| New York | 1121 |
| New Mexico | 610 |
| Georgia | 532 |
| Texas | 517 |
| Other values (44) |
| Value | Count | Frequency (%) | |
| California | 8912 | 57.8% | |
| New York | 1121 | 7.3% | |
| New Mexico | 610 | 4.0% | |
| Georgia | 532 | 3.5% | |
| Texas | 517 | 3.4% | |
| North Carolina | 499 | 3.2% | |
| Louisiana | 437 | 2.8% | |
| New Jersey | 341 | 2.2% | |
| Florida | 236 | 1.5% | |
| Illinois | 224 | 1.5% | |
| Other values (39) | 1978 | 12.8% |
Length
| Max length | 25 |
|---|---|
| Median length | 10 |
| Mean length | 9.481469462 |
| Min length | 4 |
| Distinct count | 49 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| CA | |
|---|---|
| NY | 1121 |
| NM | 610 |
| GA | 532 |
| TX | 517 |
| Other values (44) |
| Value | Count | Frequency (%) | |
| CA | 8912 | 57.8% | |
| NY | 1121 | 7.3% | |
| NM | 610 | 4.0% | |
| GA | 532 | 3.5% | |
| TX | 517 | 3.4% | |
| NC | 499 | 3.2% | |
| LA | 437 | 2.8% | |
| NJ | 341 | 2.2% | |
| FL | 236 | 1.5% | |
| IL | 224 | 1.5% | |
| Other values (39) | 1978 | 12.8% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct count | 23 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 8123 |
| Missing (%) | 52.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.119989017023613 |
|---|---|
| Minimum | 1.0 |
| Maximum | 23.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 6 |
| median | 14 |
| Q3 | 18 |
| 95-th percentile | 21 |
| Maximum | 23 |
| Range | 22 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.014638483 |
|---|---|
| Coefficient of variation (CV) | 0.5787660758 |
| Kurtosis | -1.477812356 |
| Mean | 12.11998902 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.1316306344 |
| Sum | 88282 |
| Variance | 49.20515304 |
| Value | Count | Frequency (%) | |
| 21 | 1164 | 7.6% | |
| 17 | 977 | 6.3% | |
| 8 | 856 | 5.6% | |
| 3 | 693 | 4.5% | |
| 6 | 576 | 3.7% | |
| 2 | 531 | 3.4% | |
| 14 | 467 | 3.0% | |
| 18 | 409 | 2.7% | |
| 11 | 339 | 2.2% | |
| 1 | 232 | 1.5% | |
| Other values (13) | 1040 | 6.8% | |
| (Missing) | 8123 | 52.7% |
| Value | Count | Frequency (%) | |
| 1 | 232 | 1.5% | |
| 2 | 531 | 3.4% | |
| 3 | 693 | 4.5% | |
| 4 | 97 | 0.6% | |
| 5 | 88 | 0.6% |
| Value | Count | Frequency (%) | |
| 23 | 52 | 0.3% | |
| 22 | 121 | 0.8% | |
| 21 | 1164 | 7.6% | |
| 20 | 178 | 1.2% | |
| 19 | 142 | 0.9% |
| Distinct count | 63 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| Strain/Injury by Misc | 1577 |
|---|---|
| Strain/Injury by Lifting | 1193 |
| Struck by Falling/Flying Object | 916 |
| Misc, Other | 838 |
| Fall/Slip, Same Level | 795 |
| Other values (58) |
| Value | Count | Frequency (%) | |
| Strain/Injury by Misc | 1577 | 10.2% | |
| Strain/Injury by Lifting | 1193 | 7.7% | |
| Struck by Falling/Flying Object | 916 | 5.9% | |
| Misc, Other | 838 | 5.4% | |
| Fall/Slip, Same Level | 795 | 5.2% | |
| Misc, Foreign Body in Eye | 778 | 5.0% | |
| Cut/Puncture/Scrape, Object Lift/Handled | 751 | 4.9% | |
| Strike/Step On, Fixed Object | 711 | 4.6% | |
| Fall/Slip, Misc | 631 | 4.1% | |
| Fall/Slip, Different Level | 545 | 3.5% | |
| Other values (53) | 6672 | 43.3% |
Length
| Max length | 40 |
|---|---|
| Median length | 25 |
| Mean length | 25.54812747 |
| Min length | 9 |
| Distinct count | 63 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.893749594340235 |
|---|---|
| Minimum | 1 |
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 29 |
| median | 58 |
| Q3 | 77 |
| 95-th percentile | 99 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.95204326 |
|---|---|
| Coefficient of variation (CV) | 0.4909856488 |
| Kurtosis | -1.189589794 |
| Mean | 54.89374959 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | -0.1202439998 |
| Sum | 845748 |
| Variance | 726.4126359 |
| Value | Count | Frequency (%) | |
| 60 | 1577 | 10.2% | |
| 56 | 1193 | 7.7% | |
| 75 | 916 | 5.9% | |
| 99 | 838 | 5.4% | |
| 29 | 795 | 5.2% | |
| 87 | 778 | 5.0% | |
| 17 | 751 | 4.9% | |
| 68 | 711 | 4.6% | |
| 31 | 631 | 4.1% | |
| 25 | 545 | 3.5% | |
| Other values (53) | 6672 | 43.3% |
| Value | Count | Frequency (%) | |
| 1 | 23 | 0.1% | |
| 2 | 49 | 0.3% | |
| 3 | 7 | < 0.1% | |
| 4 | 31 | 0.2% | |
| 5 | 28 | 0.2% |
| Value | Count | Frequency (%) | |
| 99 | 838 | 5.4% | |
| 97 | 350 | 2.3% | |
| 94 | 20 | 0.1% | |
| 90 | 232 | 1.5% | |
| 89 | 3 | < 0.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| Domestic | |
|---|---|
| Foreign | 217 |
| Value | Count | Frequency (%) | |
| Domestic | 15190 | 98.6% | |
| Foreign | 217 | 1.4% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.985915493 |
| Min length | 7 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| D | |
|---|---|
| F | 217 |
| Value | Count | Frequency (%) | |
| D | 15190 | 98.6% | |
| F | 217 | 1.4% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 3633 |
|---|---|
| Unique (%) | 23.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| 8/31/2011 | 15 |
|---|---|
| 7/24/2012 | 15 |
| 6/17/2013 | 15 |
| 3/26/2012 | 14 |
| 6/27/2014 | 14 |
| Other values (3628) |
| Value | Count | Frequency (%) | |
| 8/31/2011 | 15 | 0.1% | |
| 7/24/2012 | 15 | 0.1% | |
| 6/17/2013 | 15 | 0.1% | |
| 3/26/2012 | 14 | 0.1% | |
| 6/27/2014 | 14 | 0.1% | |
| 11/22/2011 | 14 | 0.1% | |
| 12/10/2002 | 14 | 0.1% | |
| 8/26/2011 | 14 | 0.1% | |
| 4/5/2004 | 13 | 0.1% | |
| 11/14/2002 | 13 | 0.1% | |
| Other values (3623) | 15266 | 99.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.944246122 |
| Min length | 8 |
| Distinct count | 4355 |
|---|---|
| Unique (%) | 28.5% |
| Missing | 146 |
| Missing (%) | 0.9% |
| Memory size | 120.4 KiB |
| 8/15/2005 | 15 |
|---|---|
| 8/30/2011 | 14 |
| 6/5/2013 | 13 |
| 9/20/2011 | 13 |
| 9/13/2011 | 13 |
| Other values (4350) |
| Value | Count | Frequency (%) | |
| 8/15/2005 | 15 | 0.1% | |
| 8/30/2011 | 14 | 0.1% | |
| 6/5/2013 | 13 | 0.1% | |
| 9/20/2011 | 13 | 0.1% | |
| 9/13/2011 | 13 | 0.1% | |
| 7/31/2013 | 12 | 0.1% | |
| 7/24/2002 | 12 | 0.1% | |
| 8/2/2012 | 12 | 0.1% | |
| 3/19/2009 | 12 | 0.1% | |
| 4/20/2011 | 12 | 0.1% | |
| Other values (4345) | 15133 | 98.2% | |
| (Missing) | 146 | 0.9% |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.882196404 |
| Min length | 3 |
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| Unknown/Other | |
|---|---|
| Full-Time | 2440 |
| Seasonal | 190 |
| Part-Time | 97 |
| Piece Worker | 66 |
| Other values (7) | 50 |
| Value | Count | Frequency (%) | |
| Unknown/Other | 12564 | 81.5% | |
| Full-Time | 2440 | 15.8% | |
| Seasonal | 190 | 1.2% | |
| Part-Time | 97 | 0.6% | |
| Piece Worker | 66 | 0.4% | |
| On Strike | 18 | 0.1% | |
| Apprenticeship Full-Time | 14 | 0.1% | |
| Disabled | 9 | 0.1% | |
| Retired | 3 | < 0.1% | |
| Volunteer | 2 | < 0.1% | |
| Other values (2) | 4 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 13 |
| Mean length | 12.27740637 |
| Min length | 7 |
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| 7 | |
|---|---|
| 1 | 2440 |
| 8 | 190 |
| 2 | 97 |
| C | 66 |
| Other values (7) | 50 |
| Value | Count | Frequency (%) | |
| 7 | 12564 | 81.5% | |
| 1 | 2440 | 15.8% | |
| 8 | 190 | 1.2% | |
| 2 | 97 | 0.6% | |
| C | 66 | 0.4% | |
| 4 | 18 | 0.1% | |
| A | 14 | 0.1% | |
| 5 | 9 | 0.1% | |
| 6 | 3 | < 0.1% | |
| 9 | 2 | < 0.1% | |
| Other values (2) | 4 | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 4430 |
|---|---|
| Unique (%) | 28.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| 10/3/2005 | 25 |
|---|---|
| 6/21/2005 | 19 |
| 6/22/2005 | 18 |
| 6/20/2013 | 16 |
| 9/30/2011 | 15 |
| Other values (4425) |
| Value | Count | Frequency (%) | |
| 10/3/2005 | 25 | 0.2% | |
| 6/21/2005 | 19 | 0.1% | |
| 6/22/2005 | 18 | 0.1% | |
| 6/20/2013 | 16 | 0.1% | |
| 9/30/2011 | 15 | 0.1% | |
| 8/30/2011 | 14 | 0.1% | |
| 4/20/2011 | 13 | 0.1% | |
| 10/3/2003 | 13 | 0.1% | |
| 5/6/2009 | 13 | 0.1% | |
| 2/23/2001 | 13 | 0.1% | |
| Other values (4420) | 15248 | 99.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.932563121 |
| Min length | 8 |
Handling Office Name
Categorical
| Distinct count | 28 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| LOS ANGELE | |
|---|---|
| SACRAMENTO | |
| DALLAS WC | 1345 |
| NEW JERSEY | 861 |
| LONG ISLAN | 534 |
| Other values (23) |
| Value | Count | Frequency (%) | |
| LOS ANGELE | 7112 | 46.2% | |
| SACRAMENTO | 1884 | 12.2% | |
| DALLAS WC | 1345 | 8.7% | |
| NEW JERSEY | 861 | 5.6% | |
| LONG ISLAN | 534 | 3.5% | |
| WC SOUTHEA | 522 | 3.4% | |
| CHARLOTTE | 515 | 3.3% | |
| IN-STATE A | 353 | 2.3% | |
| ATLANTA | 297 | 1.9% | |
| ILLINOIS | 281 | 1.8% | |
| Other values (18) | 1703 | 11.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.69942234 |
| Min length | 6 |
| Distinct count | 15344 |
|---|---|
| Unique (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| WORKING IN WOODED TALL GRASS AREA - EE WAS BITTEN BY DEER TI | 17 |
|---|---|
| WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN | 7 |
| UNKNOWN | 7 |
| EMPLOYEE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON S | 7 |
| EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET. | 5 |
| Other values (15339) |
| Value | Count | Frequency (%) | |
| WORKING IN WOODED TALL GRASS AREA - EE WAS BITTEN BY DEER TI | 17 | 0.1% | |
| WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN | 7 | < 0.1% | |
| UNKNOWN | 7 | < 0.1% | |
| EMPLOYEE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON S | 7 | < 0.1% | |
| EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET. | 5 | < 0.1% | |
| EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET | 4 | < 0.1% | |
| EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET - P | 3 | < 0.1% | |
| COMPLAINED OF EYE IRRITATION UPON INSERTION OF CONTACT LENS. | 2 | < 0.1% | |
| WHILE EE WORKING ON SET LOCATION HE DEVELOPED MULTIPLE PUSTU | 2 | < 0.1% | |
| EE EXPERIENCED A CHEMICAL REACTION TO THE FUMES WHEN HE WAS | 2 | < 0.1% | |
| Other values (15334) | 15351 | 99.6% |
Length
| Max length | 60 |
|---|---|
| Median length | 60 |
| Mean length | 57.90601675 |
| Min length | 7 |
| Distinct count | 1340 |
|---|---|
| Unique (%) | 8.7% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 120.4 KiB |
| LOS ANGELES | |
|---|---|
| UNKNOWN | 1538 |
| BURBANK | 1506 |
| NEW ORLEANS | 610 |
| NEW YORK | 393 |
| Other values (1335) |
| Value | Count | Frequency (%) | |
| LOS ANGELES | 2294 | 14.9% | |
| UNKNOWN | 1538 | 10.0% | |
| BURBANK | 1506 | 9.8% | |
| NEW ORLEANS | 610 | 4.0% | |
| NEW YORK | 393 | 2.6% | |
| BROOKLYN | 388 | 2.5% | |
| WILMINGTON | 328 | 2.1% | |
| CULVER CITY | 298 | 1.9% | |
| AUSTIN | 261 | 1.7% | |
| ATLANTA | 222 | 1.4% | |
| Other values (1330) | 7568 | 49.1% |
Length
| Max length | 19 |
|---|---|
| Median length | 8 |
| Mean length | 9.119101707 |
| Min length | 1 |
| Distinct count | 1841 |
|---|---|
| Unique (%) | 15.7% |
| Missing | 3684 |
| Missing (%) | 23.9% |
| Memory size | 120.4 KiB |
| 91502 | 1369 |
|---|---|
| 95816 | 406 |
| 90038 | 303 |
| 90001 | 222 |
| 90028 | 219 |
| Other values (1836) |
| Value | Count | Frequency (%) | |
| 91502 | 1369 | 8.9% | |
| 95816 | 406 | 2.6% | |
| 90038 | 303 | 2.0% | |
| 90001 | 222 | 1.4% | |
| 90028 | 219 | 1.4% | |
| 91505 | 199 | 1.3% | |
| 90232 | 171 | 1.1% | |
| 91504 | 167 | 1.1% | |
| 91608 | 158 | 1.0% | |
| 91521 | 127 | 0.8% | |
| Other values (1831) | 8382 | 54.4% | |
| (Missing) | 3684 | 23.9% |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 4.513467904 |
| Min length | 3 |
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 12 |
| Missing (%) | 0.1% |
| Memory size | 120.4 KiB |
| California | |
|---|---|
| New York | 1356 |
| Louisiana | 1132 |
| Georgia | 654 |
| North Carolina | 583 |
| Other values (48) |
| Value | Count | Frequency (%) | |
| California | 8019 | 52.0% | |
| New York | 1356 | 8.8% | |
| Louisiana | 1132 | 7.3% | |
| Georgia | 654 | 4.2% | |
| North Carolina | 583 | 3.8% | |
| Texas | 403 | 2.6% | |
| New Mexico | 383 | 2.5% | |
| Pennsylvania | 311 | 2.0% | |
| Michigan | 274 | 1.8% | |
| Utah | 263 | 1.7% | |
| Other values (43) | 2017 | 13.1% |
Length
| Max length | 25 |
|---|---|
| Median length | 10 |
| Mean length | 9.506003765 |
| Min length | 3 |
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 12 |
| Missing (%) | 0.1% |
| Memory size | 120.4 KiB |
| CA | |
|---|---|
| NY | 1356 |
| LA | 1132 |
| GA | 654 |
| NC | 583 |
| Other values (48) |
| Value | Count | Frequency (%) | |
| CA | 8019 | 52.0% | |
| NY | 1356 | 8.8% | |
| LA | 1132 | 7.3% | |
| GA | 654 | 4.2% | |
| NC | 583 | 3.8% | |
| TX | 403 | 2.6% | |
| NM | 383 | 2.5% | |
| PA | 311 | 2.0% | |
| MI | 274 | 1.8% | |
| UT | 263 | 1.7% | |
| Other values (43) | 2017 | 13.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.000778867 |
| Min length | 2 |
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| California | |
|---|---|
| New York | 1525 |
| Louisiana | 851 |
| Georgia | 565 |
| North Carolina | 535 |
| Other values (42) |
| Value | Count | Frequency (%) | |
| California | 9094 | 59.0% | |
| New York | 1525 | 9.9% | |
| Louisiana | 851 | 5.5% | |
| Georgia | 565 | 3.7% | |
| North Carolina | 535 | 3.5% | |
| Texas | 353 | 2.3% | |
| New Mexico | 332 | 2.2% | |
| Pennsylvania | 244 | 1.6% | |
| Illinois | 241 | 1.6% | |
| Utah | 236 | 1.5% | |
| Other values (37) | 1431 | 9.3% |
Length
| Max length | 20 |
|---|---|
| Median length | 10 |
| Mean length | 9.506523009 |
| Min length | 4 |
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| CA | |
|---|---|
| NY | 1525 |
| LA | 851 |
| GA | 565 |
| NC | 535 |
| Other values (42) |
| Value | Count | Frequency (%) | |
| CA | 9094 | 59.0% | |
| NY | 1525 | 9.9% | |
| LA | 851 | 5.5% | |
| GA | 565 | 3.7% | |
| NC | 535 | 3.5% | |
| TX | 353 | 2.3% | |
| NM | 332 | 2.2% | |
| PA | 244 | 1.6% | |
| IL | 241 | 1.6% | |
| UT | 236 | 1.5% | |
| Other values (37) | 1431 | 9.3% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 11 |
| Missing (%) | 0.1% |
| Memory size | 120.4 KiB |
| Medical Only | |
|---|---|
| Lost Time |
| Value | Count | Frequency (%) | |
| Medical Only | 11684 | 75.8% | |
| Lost Time | 3712 | 24.1% | |
| (Missing) | 11 | 0.1% |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 11.27078601 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 11 |
| Missing (%) | 0.1% |
| Memory size | 120.4 KiB |
| MO | |
|---|---|
| LT |
| Value | Count | Frequency (%) | |
| MO | 11684 | 75.8% | |
| LT | 3712 | 24.1% | |
| (Missing) | 11 | 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.000713961 |
| Min length | 2 |
| Distinct count | 45 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.4 KiB |
| Strain | |
|---|---|
| Laceration | |
| Specific Injury - All Other | |
| Contusion | |
| Sprain | |
| Other values (40) |
| Value | Count | Frequency (%) | |
| Strain | 3583 | 23.3% | |
| Laceration | 2418 | 15.7% | |
| Specific Injury - All Other | 2221 | 14.4% | |
| Contusion | 1610 | 10.4% | |
| Sprain | 1025 | 6.7% | |
| Puncture | 785 | 5.1% | |
| Foreign Body | 759 | 4.9% | |
| Inflammation | 670 | 4.3% | |
| Fracture | 570 | 3.7% | |
| Infection | 200 | 1.3% | |
| Other values (35) | 1566 | 10.2% |
Length
| Max length | 59 |
|---|---|
| Median length | 9 |
| Mean length | 11.81729084 |
| Min length | 4 |
Nature of Injury/Illness Code
Real number (ℝ≥0)
| Distinct count | 45 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.65898617511521 |
|---|---|
| Minimum | 1 |
| Maximum | 91 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 36 |
| median | 43 |
| Q3 | 52 |
| 95-th percentile | 59 |
| Maximum | 91 |
| Range | 90 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 17.19567328 |
|---|---|
| Coefficient of variation (CV) | 0.4127722458 |
| Kurtosis | 0.08174911361 |
| Mean | 41.65898618 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -0.4530364745 |
| Sum | 641840 |
| Variance | 295.6911796 |
| Value | Count | Frequency (%) | |
| 52 | 3583 | 23.3% | |
| 40 | 2418 | 15.7% | |
| 59 | 2221 | 14.4% | |
| 10 | 1610 | 10.4% | |
| 49 | 1025 | 6.7% | |
| 43 | 785 | 5.1% | |
| 25 | 759 | 4.9% | |
| 37 | 670 | 4.3% | |
| 28 | 570 | 3.7% | |
| 36 | 200 | 1.3% | |
| Other values (35) | 1566 | 10.2% |
| Value | Count | Frequency (%) | |
| 1 | 72 | 0.5% | |
| 2 | 11 | 0.1% | |
| 3 | 4 | < 0.1% | |
| 4 | 177 | 1.1% | |
| 7 | 72 | 0.5% |
| Value | Count | Frequency (%) | |
| 91 | 65 | 0.4% | |
| 90 | 120 | 0.8% | |
| 80 | 56 | 0.4% | |
| 78 | 15 | 0.1% | |
| 77 | 14 | 0.1% |
| Distinct count | 9 |
|---|---|
| Unique (%) | 1.5% |
| Missing | 14808 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9131886477462436 |
|---|---|
| Minimum | 1.0 |
| Maximum | 18.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.334821653 |
|---|---|
| Coefficient of variation (CV) | 0.6976947384 |
| Kurtosis | 38.79484103 |
| Mean | 1.913188648 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.345641318 |
| Sum | 1146 |
| Variance | 1.781748846 |
| Value | Count | Frequency (%) | |
| 1 | 281 | 1.8% | |
| 2 | 187 | 1.2% | |
| 3 | 84 | 0.5% | |
| 4 | 29 | 0.2% | |
| 5 | 8 | 0.1% | |
| 6 | 4 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| (Missing) | 14808 | 96.1% |
| Value | Count | Frequency (%) | |
| 1 | 281 | 1.8% | |
| 2 | 187 | 1.2% | |
| 3 | 84 | 0.5% | |
| 4 | 29 | 0.2% | |
| 5 | 8 | 0.1% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 5 | 8 | 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 120.4 KiB |
| Injury | |
|---|---|
| Skin disorder | 156 |
| Respiratory condition | 60 |
| Poisoning | 27 |
| Hearing loss | 26 |
| Value | Count | Frequency (%) | |
| Injury | 15128 | 98.2% | |
| Skin disorder | 156 | 1.0% | |
| Respiratory condition | 60 | 0.4% | |
| Poisoning | 27 | 0.2% | |
| Hearing loss | 26 | 0.2% | |
| All other illnesses | 8 | 0.1% | |
| (Missing) | 2 | < 0.1% |
Length
| Max length | 21 |
|---|---|
| Median length | 6 |
| Mean length | 6.151035244 |
| Min length | 3 |
OSHA Injury Type Code
Real number (ℝ≥0)
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0325219084712756 |
|---|---|
| Minimum | 1.0 |
| Maximum | 6.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2835746844 |
|---|---|
| Coefficient of variation (CV) | 0.2746427772 |
| Kurtosis | 142.0491387 |
| Mean | 1.032521908 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.12582568 |
| Sum | 15906 |
| Variance | 0.08041460165 |
| Value | Count | Frequency (%) | |
| 1 | 15128 | 98.2% | |
| 2 | 156 | 1.0% | |
| 3 | 60 | 0.4% | |
| 4 | 27 | 0.2% | |
| 5 | 26 | 0.2% | |
| 6 | 8 | 0.1% | |
| (Missing) | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 15128 | 98.2% | |
| 2 | 156 | 1.0% | |
| 3 | 60 | 0.4% | |
| 4 | 27 | 0.2% | |
| 5 | 26 | 0.2% |
| Value | Count | Frequency (%) | |
| 6 | 8 | 0.1% | |
| 5 | 26 | 0.2% | |
| 4 | 27 | 0.2% | |
| 3 | 60 | 0.4% | |
| 2 | 156 | 1.0% |
| Distinct count | 10 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 344 |
| Missing (%) | 2.2% |
| Memory size | 120.4 KiB |
| No Serious Injury Indicated | |
|---|---|
| Fatality | 19 |
| Fractured Bone(s) | 15 |
| Back Injury involving Surgery/Extended Disability | 10 |
| Involves AIDS, Herpes, TSS, Cancer, Other Diseases | 5 |
| Other values (5) | 14 |
| Value | Count | Frequency (%) | |
| No Serious Injury Indicated | 15000 | 97.4% | |
| Fatality | 19 | 0.1% | |
| Fractured Bone(s) | 15 | 0.1% | |
| Back Injury involving Surgery/Extended Disability | 10 | 0.1% | |
| Involves AIDS, Herpes, TSS, Cancer, Other Diseases | 5 | < 0.1% | |
| Heart Attack or Cardio-Vascular Accident | 4 | < 0.1% | |
| Serious Head Injury | 4 | < 0.1% | |
| Serious Burns | 2 | < 0.1% | |
| Minor Amputation | 2 | < 0.1% | |
| Major Amputation | 2 | < 0.1% | |
| (Missing) | 344 | 2.2% |
Length
| Max length | 50 |
|---|---|
| Median length | 27 |
| Mean length | 26.44934121 |
| Min length | 3 |
| Distinct count | 10 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 344 |
| Missing (%) | 2.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.983270264887473 |
|---|---|
| Minimum | 1.0 |
| Maximum | 15.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 15 |
| Range | 14 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3783217512 |
|---|---|
| Coefficient of variation (CV) | 0.03789557341 |
| Kurtosis | 459.3414733 |
| Mean | 9.983270265 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -19.43872707 |
| Sum | 150378 |
| Variance | 0.1431273474 |
| Value | Count | Frequency (%) | |
| 10 | 15000 | 97.4% | |
| 1 | 19 | 0.1% | |
| 9 | 15 | 0.1% | |
| 7 | 10 | 0.1% | |
| 14 | 5 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 4 | 4 | < 0.1% | |
| 15 | 2 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| (Missing) | 344 | 2.2% |
| Value | Count | Frequency (%) | |
| 1 | 19 | 0.1% | |
| 2 | 2 | < 0.1% | |
| 4 | 4 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 6 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15 | 2 | < 0.1% | |
| 14 | 5 | < 0.1% | |
| 10 | 15000 | 97.4% | |
| 9 | 15 | 0.1% | |
| 7 | 10 | 0.1% |
| Distinct count | 581 |
|---|---|
| Unique (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1010.9847471928344 |
|---|---|
| Minimum | 0 |
| Maximum | 2359 |
| Zeros | 2828 |
| Zeros (%) | 18.4% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 615 |
| median | 1035 |
| Q3 | 1510 |
| 95-th percentile | 2025 |
| Maximum | 2359 |
| Range | 2359 |
| Interquartile range (IQR) | 895 |
Descriptive statistics
| Standard deviation | 660.7386831 |
|---|---|
| Coefficient of variation (CV) | 0.6535594973 |
| Kurtosis | -0.9523935227 |
| Mean | 1010.984747 |
| Median Absolute Deviation (MAD) | 465 |
| Skewness | -0.1933581149 |
| Sum | 15576242 |
| Variance | 436575.6074 |
| Value | Count | Frequency (%) | |
| 0 | 2828 | 18.4% | |
| 1000 | 661 | 4.3% | |
| 1400 | 538 | 3.5% | |
| 1100 | 530 | 3.4% | |
| 1500 | 470 | 3.1% | |
| 900 | 407 | 2.6% | |
| 1600 | 401 | 2.6% | |
| 1300 | 386 | 2.5% | |
| 800 | 384 | 2.5% | |
| 1700 | 300 | 1.9% | |
| Other values (571) | 8502 | 55.2% |
| Value | Count | Frequency (%) | |
| 0 | 2828 | 18.4% | |
| 1 | 2 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 15 | 0.1% |
| Value | Count | Frequency (%) | |
| 2359 | 2 | < 0.1% | |
| 2355 | 7 | < 0.1% | |
| 2353 | 1 | < 0.1% | |
| 2350 | 7 | < 0.1% | |
| 2348 | 1 | < 0.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 53 |
| Missing (%) | 0.3% |
| Memory size | 120.4 KiB |
| Specific Injury | |
|---|---|
| Cumulative Trauma | 159 |
| Value | Count | Frequency (%) | |
| Specific Injury | 15195 | 98.6% | |
| Cumulative Trauma | 159 | 1.0% | |
| (Missing) | 53 | 0.3% |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 14.97936003 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 53 |
| Missing (%) | 0.3% |
| Memory size | 120.4 KiB |
| 3 | |
|---|---|
| 1 | 159 |
| Value | Count | Frequency (%) | |
| 3 | 15195 | 98.6% | |
| 1 | 159 | 1.0% | |
| (Missing) | 53 | 0.3% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Policy Year
Real number (ℝ≥0)
| Distinct count | 15 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2007.6086194586876 |
|---|---|
| Minimum | 2000 |
| Maximum | 2014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 120.4 KiB |
Quantile statistics
| Minimum | 2000 |
|---|---|
| 5-th percentile | 2000 |
| Q1 | 2004 |
| median | 2008 |
| Q3 | 2011 |
| 95-th percentile | 2014 |
| Maximum | 2014 |
| Range | 14 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.268828711 |
|---|---|
| Coefficient of variation (CV) | 0.002126325156 |
| Kurtosis | -1.203913341 |
| Mean | 2007.608619 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.1645031735 |
| Sum | 30931226 |
| Variance | 18.22289857 |
| Value | Count | Frequency (%) | |
| 2011 | 1440 | 9.3% | |
| 2013 | 1325 | 8.6% | |
| 2012 | 1196 | 7.8% | |
| 2005 | 1141 | 7.4% | |
| 2014 | 1123 | 7.3% | |
| 2010 | 1095 | 7.1% | |
| 2004 | 1029 | 6.7% | |
| 2008 | 969 | 6.3% | |
| 2002 | 950 | 6.2% | |
| 2009 | 932 | 6.0% | |
| Other values (5) | 4207 | 27.3% |
| Value | Count | Frequency (%) | |
| 2000 | 778 | 5.0% | |
| 2001 | 697 | 4.5% | |
| 2002 | 950 | 6.2% | |
| 2003 | 908 | 5.9% | |
| 2004 | 1029 | 6.7% |
| Value | Count | Frequency (%) | |
| 2014 | 1123 | 7.3% | |
| 2013 | 1325 | 8.6% | |
| 2012 | 1196 | 7.8% | |
| 2011 | 1440 | 9.3% | |
| 2010 | 1095 | 7.1% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 6313 |
| Missing (%) | 41.0% |
| Memory size | 120.4 KiB |
| California Refom 1 | |
|---|---|
| California Refom 0 | |
| California Reform 2 |
| Value | Count | Frequency (%) | |
| California Refom 1 | 4983 | 32.3% | |
| California Refom 0 | 3022 | 19.6% | |
| California Reform 2 | 1089 | 7.1% | |
| (Missing) | 6313 | 41.0% |
Length
| Max length | 19 |
|---|---|
| Median length | 18 |
| Mean length | 11.92444993 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Obs_ID | Dependent | Average Weekly Wage | Body Part | Body Part Code | Cause | Cause Code | Claimant Age | Claimant Atty Firm Name | Claimant Gender | Claimant Gender Code | Claimant Hire Date | Claimant Marital Status | Claimant Marital Status Code | Claimant State | Claimant State Code | Department Code | Detail Cause | Detail Cause Code | Domestic vs. Foreign? | Domestic vs. Foreign? Code | Dt Reported to Carrier/TPA | Dt Reported to Employer | Employment Status | Employment Status Code | Date of Injury/Illness | Handling Office Name | How Injury Occurred | Injury/Illness City | Injury/Illness Postal | Injury/Illness State | Injury/Illness State Code | Jurisdiction | Jurisdiction Code | Lost Time or Medical Only? | Lost Time or Medical Only? Code | Nature of Injury/Illness | Nature of Injury/Illness Code | Number of Dependents | OSHA Injury Type | OSHA Injury Type Code | Severity Index Code | Severity Index Code Code | Time of Injury/Illness | Type of Loss | Type of Loss Code | Policy Year | Reforms_dummy | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Obs_1 | 98679 | 500 | Pelvis | 46 | Struck or Injured By | 1700 | 21.0 | NaN | Female | F | 4/3/2001 | NaN | NaN | California | CA | NaN | Struck by Falling/Flying Object | 75 | Domestic | D | 4/17/2001 | 4/13/2001 | Full-Time | 1 | 4/13/2001 | LOS ANGELE | GOING DOWN SKI HILL ON AN AIR MATTRESS AS PART OF A SKIT, | PORTLAND | 97201 | Oregon | OR | California | CA | Lost Time | LT | Fracture | 28 | NaN | Injury | 1.0 | Fractured Bone(s) | 9.0 | 1430 | Specific Injury | 3.0 | 2001 | California Refom 0 |
| 1 | Obs_2 | 55727 | 1,037.00 | Low Back Area | 42 | Strain or Injury By | 1500 | NaN | NaN | Male | M | 5/15/2001 | NaN | NaN | California | CA | NaN | Strain/Injury by Lifting | 56 | Domestic | D | 5/25/2001 | 5/24/2001 | Full-Time | 1 | 5/22/2001 | IN-STATE A | REPETITIVE LIFTING OF CABLE, EE STRAINED LOWER BACK | PEARL HARBOR | NaN | Hawaii | HI | Hawaii | HI | Lost Time | LT | Strain | 52 | 1.0 | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Specific Injury | 3.0 | 2001 | NaN |
| 2 | Obs_3 | 185833 | 929 | Low Back Area | 42 | Strain or Injury By | 1500 | 63.0 | TROBINSON & CHUR ATTORNEYS AT LAW | Male | M | 5/15/2001 | Married | M | Hawaii | HI | NaN | Strain/Injury by Carrying | 55 | Domestic | D | 5/31/2001 | 5/22/2001 | Unknown/Other | 7 | 5/22/2001 | IN-STATE A | STRAINED LOW BACK MOVING A PALM TREE WITH CO-WORKER | PEARL HARBOR | 96860 | Hawaii | HI | Hawaii | HI | Lost Time | LT | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Specific Injury | 3.0 | 2001 | NaN |
| 3 | Obs_4 | 98615 | 1,226.00 | Multiple Body Parts | 90 | Strain or Injury By | 1500 | 49.0 | IBARRY STEVENS;;M;; | Male | M | NaN | NaN | NaN | Idaho | ID | NaN | Strain/Injury by Repetitive Motion | 97 | Domestic | D | 12/31/2003 | 12/23/2003 | Unknown/Other | 7 | 3/31/2002 | LOS ANGELE | EE CLAIMS: CT 1973 -/02 TO BOTH SHOULDERS - SPINE - AND EAR | BURBANK | 91502 | California | CA | California | CA | Lost Time | LT | Specific Injury - All Other | 59 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Specific Injury | 3.0 | 2002 | California Refom 0 |
| 4 | Obs_5 | 51396 | NaN | Other Facial Soft Tissue | 18 | Miscellaneous Causes | 1900 | 51.0 | IBARRY STEVENS;;M;; | Male | M | NaN | NaN | NaN | Idaho | ID | NaN | Misc, No Physical Cause | 90 | Domestic | D | 2/18/2004 | 2/17/2004 | Unknown/Other | 7 | 8/1/2003 | LOS ANGELE | EMPLOYEE CLAIMS: CT 11/16/93 -8/1/03; PHYSICAL STRESS AND ST | BURBANK | 91502 | California | CA | California | CA | Lost Time | LT | Specific Injury - All Other | 59 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Specific Injury | 3.0 | 2003 | California Refom 0 |
| 5 | Obs_6 | 4079 | NaN | Multiple Upper Extremities | 30 | Strain or Injury By | 1500 | 55.0 | IWAX & WAX;;A;; | Male | M | NaN | NaN | NaN | California | CA | NaN | Strain/Injury by Repetitive Motion | 97 | Domestic | D | 3/19/2004 | 3/19/2004 | Unknown/Other | 7 | 12/31/2002 | LOS ANGELE | EE CLAIMS: CT 1980 -NOV 2003 TO NECK - BACK - BOTH UPPER EXT | BURBANK | 91502 | California | CA | California | CA | Lost Time | LT | Carpal Tunnel Syndrome | 78 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Cumulative Trauma | 1.0 | 2002 | California Refom 0 |
| 6 | Obs_8 | 1909 | 1,129.00 | Low Back Area | 42 | Strain or Injury By | 1500 | 49.0 | TCRAIG RICHLIN | Male | M | 1/22/2000 | NaN | NaN | California | CA | NaN | Strain/Injury by Misc | 60 | Domestic | D | 6/10/2004 | 6/7/2004 | Unknown/Other | 7 | 12/31/2000 | LOS ANGELE | EE CLAIMS CT 09/25/00 09/25/01 TO LEFT LOWER EXTREMITY AND B | UNKNOWN | NaN | California | CA | California | CA | Lost Time | LT | Specific Injury - All Other | 59 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Specific Injury | 3.0 | 2000 | California Refom 0 |
| 7 | Obs_9 | 6687 | NaN | Low Back Area | 42 | Strain or Injury By | 1500 | 36.0 | NaN | Male | M | NaN | NaN | NaN | California | CA | NaN | Strain/Injury by Repetitive Motion | 97 | Domestic | D | 7/8/2004 | 6/28/2004 | Unknown/Other | 7 | 2/21/2001 | LOS ANGELE | EE CLAIMS REPETITIVE BACK INJURY CT 8/1/99-11/03 FROM REPETI | MISSION HILLS | 91345 | California | CA | California | CA | Lost Time | LT | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Specific Injury | 3.0 | 2001 | California Refom 0 |
| 8 | Obs_10 | 5352 | NaN | Low Back Area | 42 | Strain or Injury By | 1500 | 45.0 | NaN | Male | M | NaN | NaN | NaN | California | CA | NaN | Strain/Injury by Repetitive Motion | 97 | Domestic | D | 7/8/2004 | 7/2/2004 | Unknown/Other | 7 | 4/23/2003 | LOS ANGELE | EE CLAIMS; CT 4/23/02-4/23/03 TO SPINE. BILATERAL UPPER EXTR | BURBANK | 91504 | California | CA | California | CA | Lost Time | LT | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Specific Injury | 3.0 | 2003 | California Refom 0 |
| 9 | Obs_11 | 6324 | 1,000.00 | Lower Leg | 54 | Strain or Injury By | 1500 | 45.0 | NaN | Male | M | 10/3/2002 | NaN | NaN | California | CA | NaN | Strain/Injury by Repetitive Motion | 97 | Domestic | D | 8/4/2004 | 8/2/2004 | Full-Time | 1 | 10/30/2002 | LOS ANGELE | EE CLAIMS: L LEG - VENUS THROMBOSIS WHILE WORKING IN LAS VEG | LAS VEGAS | 89104 | Nevada | NV | California | CA | Lost Time | LT | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 0 | Specific Injury | 3.0 | 2002 | California Refom 0 |
Last rows
| Obs_ID | Dependent | Average Weekly Wage | Body Part | Body Part Code | Cause | Cause Code | Claimant Age | Claimant Atty Firm Name | Claimant Gender | Claimant Gender Code | Claimant Hire Date | Claimant Marital Status | Claimant Marital Status Code | Claimant State | Claimant State Code | Department Code | Detail Cause | Detail Cause Code | Domestic vs. Foreign? | Domestic vs. Foreign? Code | Dt Reported to Carrier/TPA | Dt Reported to Employer | Employment Status | Employment Status Code | Date of Injury/Illness | Handling Office Name | How Injury Occurred | Injury/Illness City | Injury/Illness Postal | Injury/Illness State | Injury/Illness State Code | Jurisdiction | Jurisdiction Code | Lost Time or Medical Only? | Lost Time or Medical Only? Code | Nature of Injury/Illness | Nature of Injury/Illness Code | Number of Dependents | OSHA Injury Type | OSHA Injury Type Code | Severity Index Code | Severity Index Code Code | Time of Injury/Illness | Type of Loss | Type of Loss Code | Policy Year | Reforms_dummy | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15397 | Obs_19459 | 264 | NaN | Abdomen including Groin | 61 | Strain or Injury By | 1500 | 38.0 | NaN | Male | M | 1/1/2014 | NaN | NaN | Virginia | VA | 18.0 | Strain/Injury by Lifting | 56 | Domestic | D | 10/20/2014 | 10/20/2014 | Unknown/Other | 7 | 10/20/2014 | WC SOUTHEA | PATIENT WAS LIFTING LENS CASES, STATES SOMETHING DID NOT FEE | RICHMOND | 23222 | Virginia | VA | Virginia | VA | Medical Only | MO | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 830 | Specific Injury | 3.0 | 2014 | NaN |
| 15398 | Obs_19460 | 1034 | NaN | Brain | 12 | Struck or Injured By | 1700 | 48.0 | NaN | Male | M | 7/21/2014 | NaN | NaN | Florida | FL | 20.0 | Struck by Motor Vehicle | 77 | Domestic | D | 10/20/2014 | NaN | Unknown/Other | 7 | 10/17/2014 | WC SOUTHEA | EE WAS PERFORMING A STUNT WHEN HE GOT HIT BY A PICTURE CAR A | STONE MOUNTAIN | 30087 | Georgia | GA | Florida | FL | Medical Only | MO | Concussion | 7 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 2230 | Specific Injury | 3.0 | 2014 | NaN |
| 15399 | Obs_19461 | 926 | NaN | Lower Leg | 54 | Cut, Puncture, Scrape Injured By | 1200 | 60.0 | NaN | Male | M | 9/14/2014 | NaN | NaN | Arizona | AZ | 19.0 | Cut/Puncture/Scrape, Object Lift/Handled | 17 | Domestic | D | 10/21/2014 | 10/8/2014 | Unknown/Other | 7 | 10/3/2014 | WC SOUTHEA | EE STATES WHILE MOVING STEEL HE LACERATED HIS R UPPER ASPECT | FAYETTEVILLE | 30214 | Georgia | GA | Georgia | GA | Medical Only | MO | Infection | 36 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 1100 | Specific Injury | 3.0 | 2014 | NaN |
| 15400 | Obs_19463 | 780 | NaN | Shoulder(s) | 38 | Strain or Injury By | 1500 | 39.0 | NaN | Female | F | 4/30/2014 | NaN | NaN | Georgia | GA | 8.0 | Strain/Injury by Carrying | 55 | Domestic | D | 10/22/2014 | 10/20/2014 | Unknown/Other | 7 | 10/20/2014 | WC SOUTHEA | WHILE LOADING THE TRAILER EE FELT DISCOMFORT IN R SHOULDER. | SENOIA | 30276 | Georgia | GA | Georgia | GA | Medical Only | MO | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 1818 | Specific Injury | 3.0 | 2014 | NaN |
| 15401 | Obs_19467 | 0 | NaN | Hand | 35 | Cut, Puncture, Scrape Injured By | 1200 | 44.0 | NaN | Male | M | 7/26/2014 | NaN | NaN | North Carolina | NC | 8.0 | Cut/Puncture/Scrape, Hand Tool | 16 | Domestic | D | 10/24/2014 | 10/24/2014 | Unknown/Other | 7 | 10/24/2014 | WC SOUTHEA | EMPLOYEE WAS CUTTING ZIP TIES WITH A KNIFE WHEN IT SLIPPED O | WILMINGTON | 28401 | North Carolina | NC | North Carolina | NC | Medical Only | MO | Laceration | 40 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 830 | Specific Injury | 3.0 | 2014 | NaN |
| 15402 | Obs_19473 | 2405 | NaN | Knee | 53 | Fall, Slip or Trip Injury | 1300 | 21.0 | NaN | Female | F | 8/20/2014 | NaN | NaN | Georgia | GA | 6.0 | Fall/Slip, Into Opening | 28 | Domestic | D | 10/29/2014 | 10/29/2014 | Unknown/Other | 7 | 10/29/2014 | WC SOUTHEA | EMPLOYEE WAS RETRIEVING PAINT SUPPLIES FROM A TRAILER WHEN S | FAYETTEVILLE | 30214 | Georgia | GA | Georgia | GA | Medical Only | MO | Inflammation | 37 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 1115 | Specific Injury | 3.0 | 2014 | NaN |
| 15403 | Obs_19475 | 1807 | 6,486.00 | Shoulder(s) | 38 | Strain or Injury By | 1500 | 33.0 | NaN | Male | M | 10/20/2014 | NaN | NaN | Georgia | GA | 20.0 | Strain/Injury by Misc | 60 | Domestic | D | 10/30/2014 | 10/30/2014 | Full-Time | 1 | 10/30/2014 | WC SOUTHEA | PATIENT WAS IN A SCENE THAT REQUIRED HIM TO RUN, STOP AND FA | PEACHTREE CITY | NaN | Georgia | GA | Georgia | GA | Lost Time | LT | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 1558 | Specific Injury | 3.0 | 2014 | NaN |
| 15404 | Obs_19489 | 0 | NaN | Ankle | 55 | Strain or Injury By | 1500 | 33.0 | NaN | Male | M | 1/1/2014 | Unmarried, Single, Widowed, Divorced | U | Virginia | VA | 22.0 | Strain/Injury by Jumping | 54 | Domestic | D | 11/6/2014 | 11/5/2014 | Unknown/Other | 7 | 11/5/2014 | WC SOUTHEA | PATIENT JUMPED OVER A 4' WOODEN FENCE, LANDED ON UNEVEN GROU | HENRICO | 23238 | Virginia | VA | Virginia | VA | Medical Only | MO | Sprain | 49 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 1900 | Specific Injury | 3.0 | 2014 | NaN |
| 15405 | Obs_19501 | 507 | NaN | Arm | 33 | Strain or Injury By | 1500 | 34.0 | NaN | Male | M | 8/22/2014 | NaN | NaN | Georgia | GA | 3.0 | Strain/Injury by Misc | 60 | Domestic | D | 11/11/2014 | 11/10/2014 | Unknown/Other | 7 | 11/10/2014 | WC SOUTHEA | PATIENT STATED HE WAS INJURED WHEN PLASTERING WALLS. PRODUCT | HIRAM | 30141 | Georgia | GA | Georgia | GA | Medical Only | MO | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 1041 | Specific Injury | 3.0 | 2014 | NaN |
| 15406 | Obs_19510 | 0 | NaN | Low Back Area | 42 | Strain or Injury By | 1500 | 49.0 | NaN | Female | F | 10/6/2014 | NaN | NaN | Missouri | MO | 11.0 | Strain/Injury by Twisting | 53 | Domestic | D | 11/17/2014 | 11/17/2014 | Unknown/Other | 7 | 11/14/2014 | WC SOUTHEA | WHILE PERFORMING REQUIRED JOB DUTIES, EE TWISTED HER BACK, A | NASHVILLE | 37214 | Tennessee | TN | South Carolina | SC | Medical Only | MO | Strain | 52 | NaN | Injury | 1.0 | No Serious Injury Indicated | 10.0 | 1930 | Specific Injury | 3.0 | 2014 | NaN |